Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	2776
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	325.4 KiB
Average record size in memory	120.0 B

Variable types

Numeric	15

Warnings

`gross_revenue` is highly correlated with `qtde_items`	High correlation
`qtde_items` is highly correlated with `gross_revenue`	High correlation
`avg_ticket` is highly skewed (γ1 = 51.91947145)	Skewed
`frequency_purchase` is highly skewed (γ1 = 47.4307901)	Skewed
`df_index` has unique values	Unique
`recency_days` has 34 (1.2%) zeros	Zeros
`returns` has 1483 (53.4%) zeros	Zeros

Reproduction

Analysis started	2021-05-25 14:56:26.609981
Analysis finished	2021-05-25 14:56:54.997475
Duration	28.39 seconds
Software version	pandas-profiling v2.13.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2776
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2249.470101

Minimum	0
Maximum	5695
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	181.5
Q1	896.25
median	2057
Q3	3409.25
95-th percentile	4956.75
Maximum	5695
Range	5695
Interquartile range (IQR)	2513

Descriptive statistics

Standard deviation	1526.32928
Coefficient of variation (CV)	0.6785283696
Kurtosis	-0.9557705037
Mean	2249.470101
Median Absolute Deviation (MAD)	1237
Skewness	0.3806980956
Sum	6244529
Variance	2329681.071
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
623	1	< 0.1%
611	1	< 0.1%
2660	1	< 0.1%
613	1	< 0.1%
2662	1	< 0.1%
615	1	< 0.1%
617	1	< 0.1%
619	1	< 0.1%
2670	1	< 0.1%
Other values (2766)	2766	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
5695	1	< 0.1%
5685	1	< 0.1%
5679	1	< 0.1%
5654	1	< 0.1%
5648	1	< 0.1%

customer_id
Real number (ℝ_≥0)

Distinct	2768
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15278.38473

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	12347
5-th percentile	12614.5
Q1	13804.75
median	15240.5
Q3	16779.25
95-th percentile	17950.25
Maximum	18287
Range	5940
Interquartile range (IQR)	2974.5

Descriptive statistics

Standard deviation	1721.094452
Coefficient of variation (CV)	0.1126489797
Kurtosis	-1.211274453
Mean	15278.38473
Median Absolute Deviation (MAD)	1488.5
Skewness	0.01533260642
Sum	42412796
Variance	2962166.111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12370	2	0.1%
12457	2	0.1%
12431	2	0.1%
12394	2	0.1%
12422	2	0.1%
12417	2	0.1%
12455	2	0.1%
12429	2	0.1%
16384	1	< 0.1%
15002	1	< 0.1%
Other values (2758)	2758	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2763
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2904.817478

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.575
Q1	629.1775
median	1170.87
Q3	2428.115
95-th percentile	7473.3075
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1798.9375

Descriptive statistics

Standard deviation	10923.05318
Coefficient of variation (CV)	3.760323416
Kurtosis	332.2194631
Mean	2904.817478
Median Absolute Deviation (MAD)	692.215
Skewness	16.26775455
Sum	8063773.32
Variance	119313090.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
379.65	2	0.1%
1080.48	2	0.1%
734.94	2	0.1%
6382.45	2	0.1%
2339.86	2	0.1%
3226.1	2	0.1%
745.06	2	0.1%
683.56	2	0.1%
3425.69	2	0.1%
3388.4	2	0.1%
Other values (2753)	2756	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%

recency_days
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.55331412

Minimum	0
Maximum	372
Zeros	34
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.34020913
Coefficient of variation (CV)	1.208420942
Kurtosis	3.457722286
Mean	56.55331412
Median Absolute Deviation (MAD)	23
Skewness	1.902985869
Sum	156992
Variance	4670.384184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	86	3.1%
3	86	3.1%
2	85	3.1%
8	76	2.7%
10	67	2.4%
9	67	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2028	73.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.2%
1	99	3.6%
2	85	3.1%
3	86	3.1%
4	86	3.1%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%

qtde_invoices
Real number (ℝ_≥0)

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.058357349

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.069472528
Coefficient of variation (CV)	1.497018417
Kurtosis	183.9608724
Mean	6.058357349
Median Absolute Deviation (MAD)	2
Skewness	10.62312311
Sum	16818
Variance	82.25533193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	779	28.1%
3	498	17.9%
4	394	14.2%
5	238	8.6%
6	174	6.3%
7	138	5.0%
8	97	3.5%
9	70	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	279	10.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	779	28.1%
3	498	17.9%
4	394	14.2%
5	238	8.6%
6	174	6.3%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1635
Distinct (%)	58.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1700.85987

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	119.75
Q1	330.75
median	708
Q3	1488
95-th percentile	4642.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1157.25

Descriptive statistics

Standard deviation	6076.80334
Coefficient of variation (CV)	3.572783065
Kurtosis	438.0048531
Mean	1700.85987
Median Absolute Deviation (MAD)	455
Skewness	17.32743146
Sum	4721587
Variance	36927538.84
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
272	7	0.3%
1200	7	0.3%
260	7	0.3%
219	7	0.3%
394	7	0.3%
200	7	0.3%
300	7	0.3%
Other values (1625)	2700	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

Distinct	466
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.7100144

Minimum	2
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	399.75
Maximum	7838
Range	7836
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.6619927
Coefficient of variation (CV)	2.140636511
Kurtosis	337.1889651
Mean	129.7100144
Median Absolute Deviation (MAD)	45
Skewness	15.35820919
Sum	360075
Variance	77096.18218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	38	1.4%
35	34	1.2%
26	30	1.1%
29	30	1.1%
27	30	1.1%
25	28	1.0%
31	27	1.0%
15	27	1.0%
19	27	1.0%
33	26	0.9%
Other values (456)	2479	89.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	11	0.4%
3	13	0.5%
4	16	0.6%
5	16	0.6%
6	24	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%

qtde_unique_products
Real number (ℝ_≥0)

Distinct	340
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.32600865

Minimum	1
Maximum	1786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	29
median	57
Q3	105
95-th percentile	239.25
Maximum	1786
Range	1785
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	98.6969663
Coefficient of variation (CV)	1.184467706
Kurtosis	80.66590932
Mean	83.32600865
Median Absolute Deviation (MAD)	33
Skewness	6.352503105
Sum	231313
Variance	9741.091158
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	38	1.4%
24	37	1.3%
26	36	1.3%
25	35	1.3%
33	34	1.2%
28	34	1.2%
30	32	1.2%
18	32	1.2%
15	30	1.1%
52	29	1.0%
Other values (330)	2439	87.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	19	0.7%
2	13	0.5%
3	18	0.6%
4	18	0.6%
5	23	0.8%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

SKEWED

Distinct	2768
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.32262173

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.853198841
Q1	12.43801146
median	17.94212763
Q3	25.10360946
95-th percentile	88.38245902
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	12.665598

Descriptive statistics

Standard deviation	1070.663297
Coefficient of variation (CV)	20.46272266
Kurtosis	2720.281153
Mean	52.32262173
Median Absolute Deviation (MAD)	6.347201302
Skewness	51.91947145
Sum	145247.5979
Variance	1146319.896
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27.52776471	2	0.1%
27.39248927	2	0.1%
17.98842105	2	0.1%
34.63101695	2	0.1%
43.2192	2	0.1%
17.62896175	2	0.1%
36.04680851	2	0.1%
20.63668675	2	0.1%
5.206586345	1	< 0.1%
11.74787879	1	< 0.1%
Other values (2758)	2758	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

Distinct	305
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.47478386

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	66.56127228
Coefficient of variation (CV)	0.8481867551
Kurtosis	3.685559012
Mean	78.47478386
Median Absolute Deviation (MAD)	30
Skewness	1.830817529
Sum	217846
Variance	4430.402968
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35	40	1.4%
70	39	1.4%
55	37	1.3%
31	36	1.3%
45	36	1.3%
21	36	1.3%
25	35	1.3%
26	34	1.2%
46	34	1.2%
38	33	1.2%
Other values (295)	2416	87.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9	0.3%
2	5	0.2%
3	8	0.3%
4	8	0.3%
5	5	0.2%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%

returns
Real number (ℝ_≥0)

ZEROS

Distinct	23
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.124639769

Minimum	0
Maximum	45
Zeros	1483
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.375314082
Coefficient of variation (CV)	2.112066589
Kurtosis	106.8785178
Mean	1.124639769
Median Absolute Deviation (MAD)	0
Skewness	7.760908921
Sum	3122
Variance	5.642116987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	1483	53.4%
1	657	23.7%
2	270	9.7%
3	139	5.0%
4	92	3.3%
5	38	1.4%
6	32	1.2%
7	21	0.8%
9	8	0.3%
12	5	0.2%
Other values (13)	31	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1483	53.4%
1	657	23.7%
2	270	9.7%
3	139	5.0%
4	92	3.3%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%

latitude
Real number (ℝ)

Distinct	28
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.48420656

Minimum	-25.274398
Maximum	64.963051
Zeros	0
Zeros (%)	0.0%
Negative	8
Negative (%)	0.3%
Memory size	21.8 KiB

Quantile statistics

Minimum	-25.274398
5-th percentile	50.503887
Q1	55.378051
median	55.378051
Q3	55.378051
95-th percentile	55.378051
Maximum	64.963051
Range	90.237449
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.1810818
Coefficient of variation (CV)	0.09509327798
Kurtosis	165.0199907
Mean	54.48420656
Median Absolute Deviation (MAD)	0
Skewness	-11.5015348
Sum	151248.1574
Variance	26.84360861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
55.378051	2516	90.6%
51.165691	67	2.4%
46.227638	58	2.1%
40.463667	20	0.7%
50.503887	19	0.7%
46.818188	12	0.4%
39.399872	11	0.4%
-25.274398	8	0.3%
56.26392	7	0.3%
61.92411	7	0.3%
Other values (18)	51	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-25.274398	8	0.3%
1.352083	1	< 0.1%
31.046051	1	< 0.1%
35.126413	4	0.1%
35.937496	1	< 0.1%

Value	Count	Frequency (%)
64.963051	1	< 0.1%
61.92411	7	0.3%
60.472024	6	0.2%
60.128161	4	0.1%
56.26392	7	0.3%

longitude
Real number (ℝ)

Distinct	28
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.912515498

Minimum	-106.346771
Maximum	138.252924
Zeros	0
Zeros (%)	0.0%
Negative	2553
Negative (%)	92.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	-106.346771
5-th percentile	-3.435973
Q1	-3.435973
median	-3.435973
Q3	-3.435973
95-th percentile	8.227512
Maximum	138.252924
Range	244.599695
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.70248616
Coefficient of variation (CV)	-5.596025845
Kurtosis	134.0830004
Mean	-1.912515498
Median Absolute Deviation (MAD)	0
Skewness	9.898730903
Sum	-5309.143022
Variance	114.5432099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
-3.435973	2516	90.6%
10.451526	67	2.4%
2.213749	58	2.1%
-3.74922	20	0.7%
4.469936	19	0.7%
8.227512	12	0.4%
-8.224454	11	0.4%
133.775136	8	0.3%
9.501785	7	0.3%
25.748151	7	0.3%
Other values (18)	51	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-106.346771	1	< 0.1%
-95.712891	1	< 0.1%
-19.020835	1	< 0.1%
-8.24389	3	0.1%
-8.224454	11	0.4%

Value	Count	Frequency (%)
138.252924	5	0.2%
133.775136	8	0.3%
103.819836	1	< 0.1%
34.851612	1	< 0.1%
33.429859	4	0.1%

frequency_purchase
Real number (ℝ_≥0)

SKEWED

Distinct	1228
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06179287837

Minimum	0.005464480874
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.005464480874
5-th percentile	0.008771929825
Q1	0.01587301587
median	0.02451648234
Q3	0.04215136408
95-th percentile	0.1178705525
Maximum	34
Range	33.99453552
Interquartile range (IQR)	0.0262783482

Descriptive statistics

Standard deviation	0.6691989062
Coefficient of variation (CV)	10.82970925
Kurtosis	2388.815848
Mean	0.06179287837
Median Absolute Deviation (MAD)	0.01079903541
Skewness	47.4307901
Sum	171.5370303
Variance	0.447827176
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07142857143	16	0.6%
0.04761904762	15	0.5%
0.0303030303	14	0.5%
0.02857142857	14	0.5%
0.01587301587	14	0.5%
0.1428571429	13	0.5%
0.02380952381	13	0.5%
0.06451612903	13	0.5%
0.1176470588	12	0.4%
0.025	12	0.4%
Other values (1218)	2640	95.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.2%
1.5	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

Distinct	974
Distinct (%)	35.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.47744574

Minimum	1
Maximum	297.8823529
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10
median	17
Q3	27.33333333
95-th percentile	54.2125
Maximum	297.8823529
Range	296.8823529
Interquartile range (IQR)	17.33333333

Descriptive statistics

Standard deviation	17.84737266
Coefficient of variation (CV)	0.8309820856
Kurtosis	27.51624809
Mean	21.47744574
Median Absolute Deviation (MAD)	8
Skewness	3.257325104
Sum	59621.38938
Variance	318.5287107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	45	1.6%
17	30	1.1%
11	30	1.1%
14	28	1.0%
1	26	0.9%
7.5	25	0.9%
15	25	0.9%
9	25	0.9%
23	24	0.9%
9.5	24	0.9%
Other values (964)	2494	89.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	26	0.9%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	9	0.3%

Value	Count	Frequency (%)
297.8823529	1	< 0.1%
191	1	< 0.1%
135.3333333	1	< 0.1%
129.75	1	< 0.1%
125.75	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	qtde_unique_products	avg_ticket	avg_recency_days	returns	latitude	longitude	frequency_purchase	avg_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	21.0	18.152222	1.0	1.0	55.378051	-3.435973	34.000000	8.735294
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	105.0	18.904035	52.0	7.0	55.378051	-3.435973	0.028391	19.000000
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	114.0	28.902500	26.0	2.0	46.227638	2.213749	0.040431	15.466667
3	3	13748	948.25	95.0	5.0	439.0	28.0	24.0	33.866071	92.0	0.0	55.378051	-3.435973	0.017986	5.600000
4	4	15100	876.00	333.0	3.0	80.0	3.0	1.0	292.000000	20.0	3.0	55.378051	-3.435973	0.075000	1.000000
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	61.0	45.326471	26.0	5.0	55.378051	-3.435973	0.040230	7.285714
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	148.0	17.219786	19.0	6.0	55.378051	-3.435973	0.057377	15.285714
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	46.0	88.719836	39.0	2.0	55.378051	-3.435973	0.033613	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	567.0	25.543464	4.0	27.0	55.378051	-3.435973	0.243968	25.901099
9	9	16098	2005.63	87.0	7.0	613.0	67.0	34.0	29.934776	47.0	0.0	55.378051	-3.435973	0.024476	9.428571

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	qtde_unique_products	avg_ticket	avg_recency_days	returns	latitude	longitude	frequency_purchase	avg_basket_size
2766	5610	17290	525.24	3.0	2.0	404.0	102.0	92.0	5.149412	13.0	0.0	55.378051	-3.435973	0.153846	47.000000
2767	5619	14785	77.40	10.0	2.0	84.0	3.0	2.0	25.800000	5.0	0.0	55.378051	-3.435973	0.400000	1.500000
2768	5620	17254	272.44	4.0	2.0	252.0	112.0	100.0	2.432500	11.0	0.0	55.378051	-3.435973	0.181818	55.500000
2769	5636	17232	421.52	2.0	2.0	203.0	36.0	30.0	11.708889	12.0	0.0	55.378051	-3.435973	0.166667	17.500000
2770	5637	17468	137.00	10.0	2.0	116.0	5.0	5.0	27.400000	4.0	0.0	55.378051	-3.435973	0.500000	2.500000
2771	5648	13596	697.04	5.0	2.0	406.0	166.0	133.0	4.199036	7.0	0.0	55.378051	-3.435973	0.285714	69.000000
2772	5654	14893	1237.85	9.0	2.0	799.0	73.0	72.0	16.956849	2.0	0.0	55.378051	-3.435973	1.000000	36.500000
2773	5679	14126	706.13	7.0	3.0	508.0	15.0	14.0	47.075333	3.0	1.0	55.378051	-3.435973	1.000000	5.000000
2774	5685	13521	1092.39	1.0	3.0	733.0	435.0	312.0	2.511241	4.0	0.0	55.378051	-3.435973	0.333333	135.333333
2775	5695	15060	301.84	8.0	4.0	262.0	120.0	80.0	2.515333	1.0	0.0	55.378051	-3.435973	4.000000	27.500000

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows